<?php
/**
 * $Id$
 *
 * PHP versions 5
 *
 * Copyright (c) 2012, PANEL_CONROLLER
 * All rights reserved.
 * Redistribution and use in source and binary forms, with or without
 * modification, are permitted provided that the following conditions are met:
 *
 *     * Redistributions of source code must retain the above copyright
 *       notice, this list of conditions and the following disclaimer.
 *     * Redistributions in binary form must reproduce the above copyright
 *       notice, this list of conditions and the following disclaimer in the
 *       documentation and/or other materials provided with the distribution.
 *     * Neither the name of the University of California, Berkeley nor the
 *       names of its contributors may be used to endorse or promote products
 *       derived from this software without specific prior written permission.
 *
 * THIS SOFTWARE IS PROVIDED BY THE REGENTS AND CONTRIBUTORS "AS IS" AND ANY
 * EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
 * WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
 * DISCLAIMED. IN NO EVENT SHALL THE REGENTS AND CONTRIBUTORS BE LIABLE FOR ANY
 * DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES
 * (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
 * LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
 * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
 * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
 * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
 *
 * @author     Ivan Martins
 * @author     Ivan Martins
 * @copyright  
 * @license    BSD
 * @version    $Id$
 * @link       
 * @since      2012
 */
 if (strpos($_SERVER["SCRIPT_NAME"],"database2.class.php")!=FALSE) {
  header("Location: ../index.php");
  exit;
}
require_once("database2.class.php");
class  Respondent{
function addObject(){

}//end function
	

function updateObject() {

}//end function


function removeObject() {

}//end function

//metodo para listar respondents sem qualquer filtro
function listObject() {
$db = new Banco();
$db->abrir();
$result = mysql_query("SELECT
	idrespondent AS ID , 
	name AS NAME, 
	familyname AS SURNAME,
	email AS EMAIL,
	sex AS SEX, 
	birthday AS BIRTHDAY, 
	countryname AS COUNTRY,
	nationalityname AS NATIONALITY,
	languagename AS LANGUAGE, 
	registroem AS RESGISTRED 
	FROM `qls_respondents`
	JOIN `qls_countries`
	ON fk_country = idcountry
	JOIN `qls_nationalities`
	ON fk_nationality = idnationality
	JOIN `qls_languages`
	ON fk_language = idlanguage
	");
return $result;
$db->fechar();

}//end function


function searchObject($id) {

$db = new Banco();
$db->abrir();

$condicao = "WHERE idrespondent=".$id;


$result = mysql_query("SELECT
	idrespondent AS ID , 
	name AS NAME, 
	familyname AS SURNAME,
	email AS EMAIL
	FROM `qls_respondents` 
	".$condicao);
return $result;
$db->fechar();

}//end function	




function filterObject($keyword) {
$db = new Banco();
$db->abrir();
$teste = "WHERE ";

foreach($keyword as $field=>$values){
	
	
	if($values==''){
		$teste .= "";
	}elseif($field=='fk_country'||$field=='fk_language'||$field=='fk_nationality'){
		$teste .= $field." = ".$values." AND " ;
	}elseif($field=='name'||$field=='familyname'){
		$teste .= $field." LIKE '".$values."' AND ";
	}else{
		$teste .= $field."='".$values."' AND ";
	}
}

$teste = substr_replace($teste," ",-4,4);


//return $teste;
$query = "SELECT
	idrespondent AS ID , 
	name AS NAME, 
	familyname AS SURNAME,
	email AS EMAIL,
	sex AS SEX, 
	birthday AS BIRTHDAY, 
	countryname AS COUNTRY,
	nationalityname AS NATIONALITY,
	languagename AS LANGUAGE, 
	registroem AS RESGISTRED 
	FROM `qls_respondents`
	JOIN `qls_countries`
	ON fk_country = idcountry
	JOIN `qls_nationalities`
	ON fk_nationality = idnationality
	JOIN `qls_languages`
	ON fk_language = idlanguage 
	".$teste;
$result = mysql_query($query);
//return $query;
return $result;
$db->fechar();
}//end function






}//end class
?>